package com.bobby.service;

import com.bobby.pojo.Book;
import com.bobby.pojo.Page;

import java.sql.SQLException;
import java.util.List;

/**
 * @Description TODO
 * @Date 2020/8/14 16:04
 * @Created wenjunpei
 */
public interface BookService {

    int addBook(Book book) throws SQLException;

    int deleteBookById(Integer id) throws SQLException;

    int updateBook(Book book) throws SQLException;

    Book queryBookById(Integer id) throws SQLException;

    List<Book> queryBooks() throws SQLException;

    Page page(String pageNoStr, String pageSizeStr) throws SQLException;

    Page pageByPrice(String pageNoStr, String pageSizeStr, String minStr, String maxStr) throws SQLException;
}
